﻿CREATE VIEW [dbo].[ASMS_V_SettlementBill]
	AS 
SELECT SB.*,
	MDIIT.Name as InvoiceTypeName,
	S1.Name as CashierName
FROM ASMS_SettlementBill as SB
	left join ASMS_MasterDataItem as MDIIT on MDIIT.Code = SB.InvoiceType
	left join ASMS_Staff as S1 on S1.Id = SB.Cashier
